Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: How can we add date parameters through advance SQL in OTBI?
Hi Sushant Please try the below In the Criteria tab—>Select the required date column—>Click on Filter—>select the check box "Convert this filter to SQL"—>In the Advance SQL text…1 -
Re: How to join multiple subject areas in OTBI
Hi Dilip Please review the given documentation link Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (OTBI) (Doc ID 1567672.1) https://docs.ora…1 -
Re: How user can cancel report which is not a job?
If you want to cancel the OTBI analysis long-running report then do the following. Login into the BI application with BI Admin user-->Click on Administration-->Click on Manage sessions-->Sea…1